Release 10.1A: OpenEdge Getting Started:
Core Business Services

Querying and reporting

Because the audit data is stored in standard OpenEdge database tables, you can easily query against the table’s contents as long as you know the database schema. You can search by user ID, event ID, date, context, transaction, audit group, database connection, or authenticated client session.

You can also report on the audit data, choosing to generate either a prefiltered report or a custom filtered report. The prefiltered reports are organized by category, such as audit policy, database schema, or user accounts, and allow you to specify a date range or audit event ID range, where to output the report (terminal, printer, XML file, or text file), and whether you want the contents to appear in a detailed or a summary format. You can also generate a custom report based on criteria you choose.

For a description of the audit table schema, see Appendix A "Audit Data Tables." For more information about querying and reporting, see Chapter 14, " Querying and Reporting on Audit Data."